﻿CREATE TABLE [CoffeeShop].[Order] (
    [OrderId]              INT            IDENTITY (1, 1) NOT NULL,
    [Title]                NVARCHAR (MAX) NOT NULL,
    [StartDate]            DATETIME       NOT NULL,
    [EndDate]              DATETIME       NOT NULL,
    [ExpectedDeliveryDate] DATETIME       NOT NULL,
    [IsBervergePurchased]  BIT            NOT NULL,
    [ReasonForDelete]      NVARCHAR (MAX) NULL,
    [OrderStatusCode]      NCHAR (10)     NOT NULL
);

